Import of data from Microsoft Excel
At present sisHYD implements an import interface to Microsoft Excel for pipe class data and customer data. For the customer data, as well as the pure import, there is also the option to update data in sisHYD based on the table data.
Structure of a spreadsheet
The Excel worksheet follows a firmly defined pattern, so that sisHYD can assign the information on the worksheet to the corresponding fields in the sisHYD data model. In addition, the following rules are valid:
- The first 3 rows of the worksheet are reserved for administrative information.
- Exactly one data set is in one row of the worksheet.
- A column in the worksheet is assigned to exactly one field in the sisHYD data model. The order of the columns is arbitrary.
- In the first row there are keywords set by sisHYD which marks the allocation of the column value into the sisHYD data model. Columns without keywords are ignored. Cells with unknown keywords are provided with a comment.
- The sequence of the data records is arbitrary. However, sorting by the name attribute, which must be unique for all data records, is recommended- so doubles are immediately recognizable.
- The second row contains "plain text" for the column. Contents are not needed for the data transfer and may also be used elsewhere.
- The third row is given in the units to which the numerical values of the column to refer. The label for unit-bound fields must be displayed and be known to the sisHYD unit system. The label may be written optionally in [].
Template working folder
sisHYD makes a template with import worksheet on pipe classes and customer data available. The template working folder is found in the path relative to the sisHYD installation ./sishyd/xls/ImportLeereMappe.xls and contains 2 worksheets "pipe class" and "customer".
In the template the cells of the first row are colored according to a certain pattern:
Pipe classes
The following table contains the keywords for the allocation from worksheet columns to data fields for pipe classes. Compulsory fields for the import are marked with an asterisk (*):
Table 11
| Keyword | Description | Info. |
|---|---|---|
| * id [klasse] | Name of the pipe class. The name must be unique within all pipe class names! | |
| dimbar | It specifies whether a pipe class can be suggested in design calculations. | True False |
| * di | Inside diameter of the pipe. | m: |
| wandrau | Wall roughness. | m: |
| waermekoeff | Heat transition coefficient for heat loss calculation. Note this is not the heat coefficient often given with pipe classes (adjusts to the pipe range) (see unit). | W/m2K |
| verweilkoeff | Correction factor in unsteady state calculation. At present always 1.0. | |
| druckstufe | Nominal pressure level for the examination of the operation limit. | Pa |
| lieferant | Name of the supplier. | |
| bestell_nr | Order number with the supplier. | |
| leckdetekt | Specifies whether the pipe class has possibilities for leakage detection. | True False |
| dn | Nominal diameter of the pipe. | m: |
| da | Outside diameter of the pipe. | m: |
| s | Wall thickness of the medium pipe. | m: |
| dm | Diameter of the jacket pipe. | m: |
| material | Pipe material. | |
| isolierung | Description of the insulation material. | |
| gewicht | Specific weight per meter of pipe length. | |
| preis1 | Moving costs for self-defined category 1. | €/m |
| preis2 | Moving costs for self-defined category 2. | €/m |
| preis3 | Moving costs for self-defined category 3. | €/m |
| preis4 | Moving costs for self-defined category 4. | €/m |
| preis5 | Moving costs for self-defined category 5. | €/m |
| preis6 | Moving costs for self-defined category 6. | €/m |
| max_geschw | Optional information of a maximum speed for design calculations. The value overwrites the information from network calculation if ! = 0 | m/s |
| max_deltap | Optional information maximum spec. pressure loss for design calculations. The value overwrites the information from network calculation if ! = 0 | Pa |
| temperatur | Optional information of an outside temperature for heat loss calculation. The value overwrites the information from network calculation if the field is occupied and is >-273.15 °C. | °C |
| verlegeart | Optional information of a type of move of the pipe class. |
Customer data
The following table contains the keywords for the allocation of worksheet columns to data fields for customer data. Compulsory fields for the import are marked with an asterisk (*). A consumer group must be defined so that the heating, hot water, or ventilation portion data can be set.
Table 12
| Keyword | Description | Info. |
|---|---|---|
| * kunde | Name of the customer. The field must be unique within all customer names! | |
| * knoten1 | Assigned node with calculation without compression. The node must be already present in sisHYD. | |
| netzteil | Allocation power packs for the resulting consumer. | |
| abrechnung | Alphanumeric key field for consumption accounting systems. | |
| verbr_gruppe | Name of the consumer group for the heating portion. The group must be present in order to set the heating portion. Otherwise the field can be omitted. | |
| leistung | Connected load of the customer. | W |
| massenstrom | Mass flow of the customer in the design case (100%). | kg/s |
| volumenstrom | Flow rate of the customer in the design case (100%). | m3/s |
| max_massenstrom | Max. admissible mass flow. This field is evaluated when consumers are created and the adherence to the max. permissible value is checked. | kg/s |
| bypass | Diameter of a thermal bypass. | mm |
| waermemenge1 | Referred amount of heat in this year. | Ws |
| wassermenge1 | Referred quantity of water in this year. | kg |
| volumen1 | Referred volume in this year. | m3 |
| waermemenge2 | Referred amount of heat in the previous year. | Ws |
| wassermenge2 | Referred quantity of water in the previous year. | kg |
| volumen2 | Referred volume in the previous year. | m3 |
| wohnflaeche | Floor space. | m2 |
| verbr_gruppe2 | Name of the consumer group for the hot water preparation. The group must be present in order to set the demands for hot water preparation. Otherwise, the field can be omitted. | |
| leistung2 | Connection value for the hot water preparation. | W |
| massenstrom2 | Mass flow for the hot water preparation of the customer in kg/s design case (100%). | |
| volumenstrom2 | Volume flow for the hot water preparation of the customer m3/s in design case (100%). | |
| verbr_gruppe3 | Name of the consumer group for the ventilation portion. The group must be present in order to set the ventilation portion. Otherwise the field can be omitted. | |
| leistung3 | Connection value for the ventilation proportion. W | |
| massenstrom3 | Mass flow for the ventilation portion kg/s of the customer in design case (100%). | |
| volumenstrom3 | Volume flow for the ventilation portion m3/s of the customer in design case (100%). |